﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'proc_cm_DeleteDatabaseContentByCd')
BEGIN
    PRINT 'Dropping Procedure proc_cm_DeleteDatabaseContentByCd'
    DROP  Procedure  proc_cm_DeleteDatabaseContentByCd
END
GO

PRINT 'Creating Procedure proc_cm_DeleteDatabaseContentByCd'
GO

CREATE Procedure dbo.proc_cm_DeleteDatabaseContentByCd
	@pContentCd varchar(50)
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

	delete from tbl_v2_Content
	where content_cd = @pContentCd
END
GO

GRANT EXEC ON dbo.proc_cm_DeleteDatabaseContentByCd TO PUBLIC
GO

